<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@ page import ="ua.lk.phonebook.*, java.sql.*"  %>        
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">


<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Користувачи - Інформаційна служба 109</title>
<link rel="stylesheet" href="css/styles.css" type="text/css" />
<style>a.m-users {font-weight:bold;} </style>
</head>


<body>
<div class="menu-users">
<jsp:include page="includes/header.jsp"></jsp:include>
</div>
<h3>Список пользователей</h3>
<%
	Connection conn = Database.getConnection();
	Statement st = conn.createStatement();
	ResultSet rs = st.executeQuery("SELECT username, id, login from users");
	while(rs.next())
		  out.println(rs.getString("username")+"<br />");
	Database.close(conn);
%>

 


 </body>
</html>